create or replace procedure scott.INSERT_BOARDID_INTO_STOCK_CODE is
begin
    declare
  cursor stockCode is select * from stock_code;
  cursor board is select * from board;
  begin
         /*for i in stockCode loop
             for j in board loop
                 if i.board_name=j.board_name then
                     update stock_code set board_id=j.id where stock_code=i.stock_code;
                     dbms_output.put_line(i.board_name);
                     dbms_output.put_line(j.board_name);
                 end if;
             end loop;
         end loop;*/
         null;
  end;
end INSERT_BOARDID_INTO_STOCK_CODE;
/

